            <?php
              $sttmt = $koneksi->query("select * from member m inner join kabupaten k on k.id_kabupaten = m.id_kabupaten inner join provinsi p on p.id_provinsi = k.id_provinsi where id_member='$_SESSION[id_member]'");
              $biodata = $sttmt->Fetch(PDO::FETCH_ASSOC);
            ?>
            <div class="col-md-9">
              <!-- random product -->
              <div class="span12">
                <div class="outer-border nav-page-sidebar-p10">
                  <div class="nav-judul bg-texture margin-bottom">
                    <span class="judul-sidebar">
                      Data Diri
                    </span>
                  <div class="clearfix"></div>
                  </div>

                  <div class="nav-page-sidebar-p10">
                    <form class="form-horizontal" role="form" action="ubah-biodata.aspx" method="post">
                      <div class="form-group small">
                        <label class="col-lg-3 control-label">ID Member</label>
                        <div class="col-lg-9">
                          <input type="text" name="id_member" class="form-control input-sm" placeholder="Id Member" value="<?php echo $biodata['id_member']; ?>" disabled>
                          <input type="hidden" name="id" class="form-control input-sm" placeholder="Id Member" value="<?php echo $biodata['id_member']; ?>">
                        </div>
                      </div>
                      <div class="form-group small">
                        <label class="col-lg-3 control-label">Nama</label>
                        <div class="col-lg-9">
                          <input type="text" name="nama" class="form-control input-sm" placeholder="Nama Lengkap" value="<?php echo $biodata['nama_lengkap']; ?>">
                        </div>
                      </div>
                      <div class="form-group small">
                        <label class="col-lg-3 control-label">Alamat</label>
                        <div class="col-lg-9">
                          <input type="text" name="alamat" class="form-control input-sm" placeholder="Alamat" value="<?php echo $biodata['alamat']; ?>">
                        </div>
                      </div>
					   <div class="form-group small">
                        <label class="col-lg-3 control-label">Provinsi</label>
                        <div class="col-lg-9">
							<select class="form-control input-sm" name="provinsi" id="provinsi">
								<option value=""> - - Pilih Provinsi - - </option>
								<?php
									$provinsi = $koneksi->query("SELECT * from provinsi");
									while ($p = $provinsi->fetch(PDO::FETCH_ASSOC)){
										if($p['id_provinsi'] == $biodata['id_provinsi']){
											$sp = "selected=selected";
										}else{
											$sp = "";
										}
										echo "<option value=$p[id_provinsi] $sp>$p[provinsi]</option>";
									}
								?>
							</select>
                        </div>
                      </div>
                      <div class="form-group small">
                        <label class="col-lg-3 control-label">Kota/Kabupaten</label>
                        <div class="col-lg-9">
							<select class="form-control input-sm" name="kota">
								<option value=""> - - Pilih Kota/Kabupaten - - </option>
								<?php
									if($biodata['id_provinsi'] != ''){
										$kota = $koneksi->query("SELECT * from kabupaten where id_provinsi = $biodata[id_provinsi]");
										while ($k = $kota->fetch(PDO::FETCH_ASSOC)){
											if($k['id_kabupaten'] == $biodata['id_kabupaten']){
												$sk = "selected=selected";
											}else{
												$sk = "";
											}
											echo "<option value=$k[id_kabupaten] $sk>$k[kabupaten]</option>";
										}
									}
								?>
							</select>
                        </div>
                      </div>
                      <div class="form-group small">
                        <label class="col-lg-3 control-label">Kode Pos</label>
                        <div class="col-lg-9">
                          <input type="text" name="kode_pos" class="form-control input-sm" placeholder="Kode Pos" value="<?php echo $biodata['kd_pos']; ?>">
                        </div>
                      </div>
                      <div class="form-group small">
                        <label class="col-lg-3 control-label">Tanggal Lahir</label>
                        <div class="col-lg-9">
                            <?php
                              $tgl = explode("-","$biodata[tgl_lahir]");
                              echo "<select name=tgl class=input-sm>";
                              for($i=1;$i<=31;$i++){
                                if($i == $tgl[2]){
                                  $sl = "selected";
                                }else{
                                  $sl = "";
                                }
                                echo "<option value=$i $sl>$i</option>";
                              }
                              echo "</select>
                              <select name=bln class=input-sm>";
                              for($i=1;$i<=12;$i++){
                                if($i == $tgl[1]){
                                  $sl = "selected";
                                }else{
                                  $sl = "";
                                }
                                echo "<option value=$i $sl>$i</option>";
                              }
                              echo "</select>
                              <select name=thn class=input-sm>";
                              for($i=1950;$i<=2020;$i++){
                                if($i == $tgl[0]){
                                  $sl = "selected";
                                }else{
                                  $sl = "";
                                }
                                echo "<option value=$i $sl>$i</option>";
                              }
                            ?>
                          </select>
                        </div>
                      </div>
                      <div class="form-group small">
                        <label class="col-lg-3 control-label">Email</label>
                        <div class="col-lg-9">
                          <input type="email" name="email" class="form-control input-sm" placeholder="Email" value="<?php echo $biodata['email']; ?>">
                        </div>
                      </div>
                      <div class="form-group small">
                        <label class="col-lg-3 control-label">No. Telp</label>
                        <div class="col-lg-9">
                          <input type="text" name="telp" class="form-control input-sm" placeholder="No. Telp" value="<?php echo $biodata['no_telp']; ?>">
                        </div>
                      </div>

                      <div class="form-group">
                        <div class="col-lg-offset-3 col-lg-9">
                          <button type="submit" class="btn btn-danger btn-sm">Simpan</button>
                        </div>
                      </div>
                    </form>
                  </div>
                  
                <div class="clearfix"></div>
                </div>
              <div class="clearfix"></div>
              </div>
              <!-- end random product -->

            </div>